Multigranular Manipulations for OLAP Querying
نویسندگان
چکیده
Decisional systems are based on multidimensional databases improving OLAP analyses. This chapter describes a new OLAP operator named “BLEND” that performs multigranular analyses. This operation transforms multidimensional structures when querying in order to analyze measures according to several granularity levels like one parameter. We study valid uses of this operation in the context of strict hierarchies. Experiments within a R-OLAP implementation show the light cost of the operator.
منابع مشابه
Querying Multigranular Spatio-temporal Objects
The integrated management of both spatial and temporal components of information is crucial in order to extract significant knowledge from datasets concerning phenomena of interest to a large variety of applications. Moreover, multigranularity, i.e., the capability of representing information at different levels of detail, enhances the data modelling flexibility and improves the analysis of inf...
متن کاملQuerying Semantic Web Data Cubes
We address the problem of querying data cubes for Online Analytical Processing (OLAP) analysis, directly on the Semantic Web (SW). We rst introduce CQL, a simple algebra for querying data cubes at a conceptual level. Taking advantage of QB4OLAP metadata, we automatically translate CQL queries into SPARQL ones, and propose query optimization strategies that adapt, to the particular OLAP setting,...
متن کاملSummarizing and Querying Logs of OLAP Queries
Leveraging query logs benefits the users analyzing large data warehouses with OLAP queries. But so far nothing exists to allow the user to have concise and usable representations of what is in the log. In this article, we present a framework for summarizing and querying OLAP query logs. The basic idea is that a query summarizes another query and that a log, which is a sequence of queries, summa...
متن کاملAn OLAP Endpoint for RDF Data Analysis Using Analysis Graphs
Exploiting Resource Description Framework (RDF) data for Online Analytical Processing (OLAP), especially Linked Open Data (LOD), could allow analysts to obtain interesting insights. To conduct OLAP analysis over RDF data, analysts should know the specific semantics, structure, and querying mechanisms of such data. Furthermore, these data should ideally adhere to a multidimensional structure to ...
متن کاملOnline Analytical Processing (OLAP) for Decision Support
Nenad Jukic 1 , Boris Jukic 2 , and Mary Malliaris 1 School of Business Administration, Loyola University Chicago, Chicago, IL, USA School of Business, Clarkson University, Potsdam, NY, USA _____________________________________________________________________________________ Online Analytical Processing (OLAP) refers to the general activity of querying and presenting text and number data from d...
متن کامل